package com.geek.water.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.geek.water.entity.Site;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SiteMapper extends BaseMapper<Site> {
    @Select("SELECT * FROM site WHERE customer_id = #{customerId}")
    List<Site> findSitesByCustomerId(@Param("customerId") Long customerId);
}
